create external table jms_dim.dim_sqs_global_work_time_dt
(
    id           int ,
    provider_name  string  comment '省份名称',
    provider_code   string  comment '省份编码',
    start_time   string  comment '开始时间',
    end_time    string   comment '结束时间'
)comment '全球工单监控工作时间表';
 PARTITIONED BY (dt string COMMENT '更新/创建日期 (yyyy-MM-dd)')
 stored as parquet
 LOCATION '/dw/hive/jms_dim.db/external/dim_sqs_global_work_time_dt';